UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wgAbeVF572rHfhTYwYUk7IFmELensGllaUga1vPGGBA='
WHERE
key_id = '42a432457a8631c8c93e46e328bbac27cd7ba8b3969e4b8be4b7941c1b8963f7'
AND (
token = 'wgAbeVF572rHfhTYwYUk7IFmELensGllaUga1vPGGBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)