UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P7X0Hh9W1aQXMTOOm088hjqHfDzDzEOUkD2q0rbNjQc='
WHERE
key_id = '7d3eb32d73410e8e8b6460e9bba6f708b55b65d24a64279e36318c7ad7a182ac'
AND (
token = 'P7X0Hh9W1aQXMTOOm088hjqHfDzDzEOUkD2q0rbNjQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)