UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0bH90x/cJD9/1QPZNJWtq2C84BhW3fe0jfgIzl6qD+k='
WHERE
key_id = 'e95c5a599f18e2caae5c43cafe7f435107c48cb3e6d5a178f38686302b691cc9'
AND (
token = '0bH90x/cJD9/1QPZNJWtq2C84BhW3fe0jfgIzl6qD+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)