UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yWdWh26EsNAGzbqXGTriY/3fuJMItfzlQDwiuSTBS48='
WHERE
key_id = 'de9ecfb8a71b3958e93e9d0f6a235bee4448a167228afd35904da88375091d7d'
AND (
token = 'yWdWh26EsNAGzbqXGTriY/3fuJMItfzlQDwiuSTBS48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)