UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I8lLnPQ8oDQ/mg+i48EscFqlGVinRiGGLX3lri2rMJA='
WHERE
key_id = '638669c69690ee9afffcdb875ca99ddc71a35289359a61fe56953c9dcbe5a65f'
AND (
token = 'I8lLnPQ8oDQ/mg+i48EscFqlGVinRiGGLX3lri2rMJA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)