UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6xaTctlBnU8uyrtdDbX4rjJ0nvL3tWa+7yBI+h6PvtM='
WHERE
key_id = '8cf9dee9db62eabc970131b01038772ea955d76d85427ee0f6a330dbefc5cf30'
AND (
token = '6xaTctlBnU8uyrtdDbX4rjJ0nvL3tWa+7yBI+h6PvtM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)