UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6pekcnM19nvN1cGY6PWDZLH/EuxPfycVDiCvL8aRKqc='
WHERE
key_id = '44157a1565c9644d1f24269a33626cc5ebc46ab7edc776875bba06007e2417ee'
AND (
token = '6pekcnM19nvN1cGY6PWDZLH/EuxPfycVDiCvL8aRKqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)