UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E2DjQvZghcxIIJcg4kHkIg3BgmemNNziy0uTRi24kV8='
WHERE
key_id = '7257b90ceff390db9f902b9214ab3abab222532a49fe1f6e29103baae4a57cdc'
AND (
token = 'E2DjQvZghcxIIJcg4kHkIg3BgmemNNziy0uTRi24kV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)