UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VObuXFhy3tJ2adK/1XHbWFLlMXCin/2PPY3cjloek4g='
WHERE
key_id = 'a67a895baa08fc689fcde3db7954c7ec202a14091e64756a6d704bd5e9a152f0'
AND (
token = 'VObuXFhy3tJ2adK/1XHbWFLlMXCin/2PPY3cjloek4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)