UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p7yA2Z2zU6sQTyZ6GWfa4HZazpRfor/bt5RTV3YGHLY='
WHERE
key_id = '4e7f77a37d85df42e5d513a2f1e3b7628e205155dc51ff2ce4754d369ef1b9fd'
AND (
token = 'p7yA2Z2zU6sQTyZ6GWfa4HZazpRfor/bt5RTV3YGHLY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)