UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xfBPcQyqDWGkBm4rmqofouS3uraI4UcDhI5K+p3NMfA='
WHERE
key_id = '3d75d53fd020067c842250725867f118b5dfa85b5789548c509d3c6b62e735e4'
AND (
token = 'xfBPcQyqDWGkBm4rmqofouS3uraI4UcDhI5K+p3NMfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)