UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zHxWLUmweBUcL9jJIJXZ0Y/zfAf+icrkUu3nL9M+yPA='
WHERE
key_id = 'c7fecf63fc0cb6cb551198c1ff4d45c47cecad96fa78523d10250eefba3e96c2'
AND (
token = 'zHxWLUmweBUcL9jJIJXZ0Y/zfAf+icrkUu3nL9M+yPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)