UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KfHvSIy1pYoaDjPuPzmcYNVdoylmsE3C+wh+Zk85ax0='
WHERE
key_id = 'fed5b2645991398054ab39fec1aed72f994679a7d8384c466c98e01862f8224d'
AND (
token = 'KfHvSIy1pYoaDjPuPzmcYNVdoylmsE3C+wh+Zk85ax0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)