UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3MKvcq6PdvR2Dmn3e4jDIZuW6g0MY5f0gKv8xbmWwH0='
WHERE
key_id = '1706ef3c02c11648665c4ba655a8f6eaba0c7253d9122ac2badb6b786df37352'
AND (
token = '3MKvcq6PdvR2Dmn3e4jDIZuW6g0MY5f0gKv8xbmWwH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)