UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qRJLNivh3rg1GYSGGNJ0J3xuBwfpcv3Zg/58hr6edyY='
WHERE
key_id = '49ef4c1f55d6ff34ab1449c0f78a054f4a48767b186d7c6e46e98712eb79248f'
AND (
token = 'qRJLNivh3rg1GYSGGNJ0J3xuBwfpcv3Zg/58hr6edyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)