UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cD/jikj5CzmEzmwjRuv3IegOLu1QJzsEIWo1V6t/YBc='
WHERE
key_id = '8dbc714df0b27a03dea33c4237333beee25ee486deb0573c5d1acfa445a622db'
AND (
token = 'cD/jikj5CzmEzmwjRuv3IegOLu1QJzsEIWo1V6t/YBc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)