UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vVh0HIyok29Zc/Ta2gFXjGA3gvZOpJBld55+IMmQpPI='
WHERE
key_id = 'd7b7dc110a36c4c9e07a8476dec3a0e265a4aaa52bbf97c72e08c45335e75257'
AND (
token = 'vVh0HIyok29Zc/Ta2gFXjGA3gvZOpJBld55+IMmQpPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)