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