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