UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'otEeg1vUiLaoCF7abEv120HE+4Ynlc63J+ZwYYgwgCw='
WHERE
key_id = '065fa8b60322332dbb0b45d87ca781b65974f14253b9b546ce712bdc65a3118b'
AND (
token = 'otEeg1vUiLaoCF7abEv120HE+4Ynlc63J+ZwYYgwgCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)