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