UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XQqv1/dzc1uWu7rDQCJw8QYg9yPsqJF0SqmudPpCGow='
WHERE
key_id = '029aae158d1390ea4c1913dbc13bf004244ff90692fd707ab9276841df84f007'
AND (
token = 'XQqv1/dzc1uWu7rDQCJw8QYg9yPsqJF0SqmudPpCGow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)