UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gn41jtRG51U3KBXGI7wWrFsuebH/JSOoDIOOqNeaL+Q='
WHERE
key_id = 'cd343bc21333362b97455003d4b134750c118e6affaee089b3f207a114ca3d6c'
AND (
token = 'gn41jtRG51U3KBXGI7wWrFsuebH/JSOoDIOOqNeaL+Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)