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