UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKvCn6oQL4FoZytOIKaRa+LtvH1kkUvSr3TgzyEd0JM='
WHERE
key_id = 'a78f2d801678504cc7939f7c7108b79a7d5ef2883a018fd007cda8573f541641'
AND (
token = 'zKvCn6oQL4FoZytOIKaRa+LtvH1kkUvSr3TgzyEd0JM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)