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