UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UqTUmfAAij86JkCpjDJnjSnWvKxHT28I3B3k9oGIEs8='
WHERE
key_id = 'c8c3887ee244dad66a0e71c0e6ca713bb12999797c8aa39badcf24b679480d44'
AND (
token = 'UqTUmfAAij86JkCpjDJnjSnWvKxHT28I3B3k9oGIEs8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)