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