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