UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pC1VGOofCBAl1Y0nkzpzwA7Bo6+q+yg5l0I+PtI5hbY='
WHERE
key_id = '4eec33c3103030734c8065104d85f97970337e22d69a345c9883996604887fc1'
AND (
token = 'pC1VGOofCBAl1Y0nkzpzwA7Bo6+q+yg5l0I+PtI5hbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)