UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oz0E5sCXWYRSU0yLc9MXAHXY+mtHO1hgpN+aZE8oDVI='
WHERE
key_id = 'b99627b33a7f364edda4b3287993baa8b2294b4ef8242ab2ceeacf8203df343f'
AND (
token = 'oz0E5sCXWYRSU0yLc9MXAHXY+mtHO1hgpN+aZE8oDVI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)