UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+g+p6GmQfMV9rtqqq1LJQcxCUdqki8p2j1zifPjK8Vw='
WHERE
key_id = 'ce8ca03c8fd67f9623d5ea44280272303a1d098efa947d3fe1733b928215f585'
AND (
token = '+g+p6GmQfMV9rtqqq1LJQcxCUdqki8p2j1zifPjK8Vw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)