UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hq6a7n8BjeQHVko20k6RV7wnH7wgFeuy3j2V4UUQXlE='
WHERE
key_id = '1efb454d54f8dfaa54365b25241bfa4de3ee4d057c2a7a2135eefad58feda66c'
AND (
token = 'Hq6a7n8BjeQHVko20k6RV7wnH7wgFeuy3j2V4UUQXlE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)