UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bYhbBdCYsehr+nI0alBOQt23Qu2Su/tSP8cUc+thrWs='
WHERE
key_id = 'ca5e4ea618bfce9113cb8cdd0b2e72f01240520cd00831f9ab43d50dd3bf0449'
AND (
token = 'bYhbBdCYsehr+nI0alBOQt23Qu2Su/tSP8cUc+thrWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)