UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3aVm5LNojyD+Y6bYDSyMr7Gh5ERTBnicxF7Po8Xd5uY='
WHERE
key_id = 'e5ea16e6910b784be94dbf2ed664e65ca08c712e66a70a338cf0f5f21b79bf3b'
AND (
token = '3aVm5LNojyD+Y6bYDSyMr7Gh5ERTBnicxF7Po8Xd5uY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)