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