UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nc9JrukhFFsVyqgJFAbPsuwES3M/AB1cI8+N5PXK900='
WHERE
key_id = 'a234fccc786386a6b4dbbd6578aa14138cbd3615c1c12715c6c2b99f33f92085'
AND (
token = 'Nc9JrukhFFsVyqgJFAbPsuwES3M/AB1cI8+N5PXK900='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)