UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '36Vw4q7BwpdNd7aw6Mcwxyi6M5kQectPIC746/jHBW8='
WHERE
key_id = '1c4d46c93cf7836f0f8bdac42cdc49a87f12ed8bc78198444de2358a2e37a362'
AND (
token = '36Vw4q7BwpdNd7aw6Mcwxyi6M5kQectPIC746/jHBW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)