UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'onG+tLjhthXh9IHDt/I56b+OxvKLS/oN0mqr8+MHDGU='
WHERE
key_id = 'f3ccbf8f15a42b177026c1bf093a869c3c6eec0a1619610bf3c0b88c88da1edc'
AND (
token = 'onG+tLjhthXh9IHDt/I56b+OxvKLS/oN0mqr8+MHDGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)