UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ghlygcIVGgqjugoUPpcBkXVUbI1/KOifsGrZ822MwyY='
WHERE
key_id = 'a295bb9e3a50466f1d05190ce86ad455eb40acd75c314ae4ef0933d18574dc36'
AND (
token = 'ghlygcIVGgqjugoUPpcBkXVUbI1/KOifsGrZ822MwyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)