UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Be0t9jMTk+nASzpEKyJnDA9ahWpN3Hx9OL5mbukvVnA='
WHERE
key_id = 'cca38e959b6118290e50a26caed3ca3b0d3691674621486a6ee9b3925579ee41'
AND (
token = 'Be0t9jMTk+nASzpEKyJnDA9ahWpN3Hx9OL5mbukvVnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)