UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y7uLe4iKNRSFXHNALND+CHSXFziyM/Yv/D186N2H+s4='
WHERE
key_id = 'cc6159c8f2fca855f901654cc3d6bace2052e43e2ea195d9facf5278d647c286'
AND (
token = 'y7uLe4iKNRSFXHNALND+CHSXFziyM/Yv/D186N2H+s4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)