UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CIjt7gjGfY0zjtbSI7wbMYTbadtrDgApS5EsDT+h/bQ='
WHERE
key_id = '8241ab1210a35b4c92a85cc2c9027d215f0a27fae0978b70763100954a986f90'
AND (
token = 'CIjt7gjGfY0zjtbSI7wbMYTbadtrDgApS5EsDT+h/bQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)