UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ptLIZtS2yAa4N6d0A4SYSTpBjinCA37Wj5HkCANGsy0='
WHERE
key_id = 'dd70ab6763d3bcb999dbf48815d85ac7c9c319f6e61b2c0fda9109053ae6cdb5'
AND (
token = 'ptLIZtS2yAa4N6d0A4SYSTpBjinCA37Wj5HkCANGsy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)