UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9wKsKf6JYebNC75W0CqmpMrBVs13emw143POu/8vncQ='
WHERE
key_id = '03b64263d61d8d615d75c6ab212e5d1aa877d8a2aaa1c27382b328b0825de2d6'
AND (
token = '9wKsKf6JYebNC75W0CqmpMrBVs13emw143POu/8vncQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)