UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SKZJe07xA3hL6u0AMsKv25+metlLGBfSlXYKhUPgqmA='
WHERE
key_id = 'e5319b1edc1b4781367787ce0f8f487083ff0cef62762369a67d30b6a4378861'
AND (
token = 'SKZJe07xA3hL6u0AMsKv25+metlLGBfSlXYKhUPgqmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)