UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y1rnVfG+cmQYImFSHA/Wc3D/ty5gO7NNRN6urYvzQkg='
WHERE
key_id = '6b4bdf439b56d3f20d28dca950b5b1959dc56f96e8d9cad02db98c3526ebb136'
AND (
token = 'y1rnVfG+cmQYImFSHA/Wc3D/ty5gO7NNRN6urYvzQkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)