UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bH/esPusYULqJtE69/D/otjoFsuuli5XjQnu+LzLtoU='
WHERE
key_id = 'e8c9efa86d778de6279097e0cf644731b0ca355ed9f370ca3c828eb18a198c46'
AND (
token = 'bH/esPusYULqJtE69/D/otjoFsuuli5XjQnu+LzLtoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)