UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VmJ193qx7rTEA8HeDpu9bmhfmNzJTZWIuLDGzzinOO4='
WHERE
key_id = '8356abec93f8fc6827aa55c75a05e43f9ac493c1b116ec71fbe5680dd664e7bd'
AND (
token = 'VmJ193qx7rTEA8HeDpu9bmhfmNzJTZWIuLDGzzinOO4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)